package com.thirdgroup.dao.impl;

import com.thirdgroup.dao.OrderPhoneDao;
import com.thirdgroup.dao.base.BaseDAO;
import com.thirdgroup.pojo.vo.OrderDetailsVO;

import java.util.LinkedHashMap;
import java.util.List;

public class OrderPhoneDaoImpl extends BaseDAO<OrderDetailsVO> implements OrderPhoneDao {
    @Override
    public OrderDetailsVO select(String order) {
         String sql="select o.orderid,o.customerid,o.managerid,o.orderstatus,o.packagecost, c.customeruserName ,c.customerName ,c.customerBalance \n" +
                "from customer_info c, order_info o\n" +
                "where  o.orderID=? and o.customerId=c.customerid";
        Object[] params={order};
        return super.findOne(sql,params);
    }

}
